Moving SeisWare Projects with Microsoft® SQL Databases Stored Locally

When moving a SeisWare project with a local SQL database you may either be moving it to another local SQL Server instance, or a network SQL Server instance. The technique used will vary depending on your situation. In both cases, for the original project the SQL Server is installed on the same drive where the original project is stored, and the database is stored within the project folder. The method that you will use to move a project will be different depending on the configuration of the SQL Server of the destination project.

There are two scenarios when moving a project with a Microsoft SQL database:

• Moving from a Local SQL Server to a Local SQL Server 
• Moving from a Local SQL Server to a Network SQL Server

Moving from a Local SQL Server to a Local SQL Server 

Before moving the project ensure the "db.mdf" and "db_log.ldf" files are stored within the project folder. From the Main Launcher's Project menu select Explore. Browse to the DB folder and ensure both files are present before continuing. If the files do not exist you will need to follow the instructions for moving SeisWare projects with SQL databases stored on the network.   

Configuring Local SQL Projects 

 Local SQL projects can be configured so that the database is detached every time the project is closed. When this option is enabled you can easily move these projects by moving the entire project folder.

1. From the Project menu of the Main Launcher  select Properties. 
   

2. From the Tools menu of the Project Properties window select Options.
   

3. Enable the option to Detach local SQL Server databases when closing the project.

If this has been enabled then you can move to Step 4  of the following instructions

Moving from a Local SQL Server to a Local SQL Server 

1. From the Project menu of the Main Launcher  select Properties. 
   

2. Highlight the project and select Detach Database from the Tools menu. 
   

3. In a File Explorer window map to the project folder. 
   

4. Move the entire project folder to the new location. 
   

5. In the Project Properties window select the original project from the list and press the Delete icon . This will remove the project from the project list, but will not delete any original files. 
   

6. From the Tools menu of the Project Properties window select Attach Existing Project.

7. Redefine data paths if seismic data is not being stored in the project folder.
   

Moving from a Local SQL Server to a Network SQL Server

If moving the project from a local SQL Server to a networkSQL Server there are two techniques. Because the database isn't stored in the project folder when you have a network installation of SQL Server, you can't simply move the project folder. You need to convert the project to SQL LocalDB to make it portable, or you need to create a new project and copy all of the data, and then delete the original project. These same techniques are used when moving from a network SQL Server to another network SQL Server.

• Convert  the SQL project to a SQL LocalDB project, move the project, and convert the project to SQL
• Create a new SQL project, use Copy Project Data to populate the new project, then delete the original project